TG: oracle_dbd/924

Forwarded from Pavel V

Таблица web_events — 100 млн строк.
Колонки:
a) device_type — 'Mobile', 'Tablet', 'Desktop'; b) browser — 8 типов; c) country_code — 50 значений; d) event_time — временная метка; e) event_type — 'CLICK', 'VIEW', 'PURCHASE' Что будет наиболее эффективно?

Anonymous Quiz

Один составной B-tree (device_type, browser, country_code, event_type)

Bitmap по device_type, browser, country_code, event_type

Только индекс по event_time

Не индексировать — таблица и так летает

190 answered

www.tg-me.com/sg/Oracle Developer‍/com.oracle_dbd/924

1.1K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/924

Create: 2025-05-26
Last Update: 2025-07-03 18:46:49

BY Oracle Developer👨🏻‍💻

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/oracle_dbd/924

Oracle Developer‍ Telegram | DID YOU KNOW?

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.

What is Telegram Possible Future Strategies?

Cryptoassets enthusiasts use this application for their trade activities, and they may make donations for this cause.If somehow Telegram do run out of money to sustain themselves they will probably introduce some features that will not hinder the rudimentary principle of Telegram but provide users with enhanced and enriched experience. This could be similar to features where characters can be customized in a game which directly do not affect the in-game strategies but add to the experience.